-: Here we have interesting data.
Average hours per day spent on leisure activities by sex.
So we have both sexes, men and women.
And this is a perfect example
where you wanna stack the data
and see how much comes together.
So I'll take the entire table.
This is approximately what you want to achieve,
and let's now work on that.
We have our tasks.
Number one, insert a stacked column chart.
No problem, I'll insert a chart.
I'll go to Column and inside of a clustered column
where it would be next to each other,
I want a stacked column.
So data is on top of each other.
Let me enlarge the data, press Control + V,
and we have one category too much.
I'll just make this data selection a little smaller,
and you can see, perfect,
we have only our three categories.
We have so much space here.
We completed number one.
What is number?
Remove vertical axis and horizontal lines.
Yeah, it's very difficult like to read the data
from this axis here,
so I'll delete the axis,
and by going to Chart Design,
Add Chart Element,
I'll insert the data labels.
We have now data labels.
And what I also wanted to remove
is the horizontal lines, okay?
We don't need the lines.
I will just press delete.
Okay.
We completed task number two.
Task number three will be put legend
on the right side.
We have the legend on the bottom,
and it's like a bit difficult to read.
So I'll make the chart much, much smaller.
I really don't like it is so big.
And I will take the legend
because here the legend is really, really important.
Maybe not like that.
I will enlarge the legend like that.
Maybe a bit too big.
And now we very nicely have that highlighted.
All right, Control + V.
Number four will be change colors.
I'm using a color scheme
and you can see we can barely see
like this dataset, this dataset.
I can either make the font of the data labels white
or completely change the color.
Even though we have a nice color scheme
for our entire presentation, sometimes it's difficult
to see if there are so many categories.
I'm going to my Format options.
Shape Fill and I'll start with a normal green color.
Then I will select the next one.
Shape Fill. You can also go to More Fill Colors.
You can either pick one of the preselected one
or go to a custom color.
You can enlarge that.
You can go to a green, maybe a much, much lighter green.
It should look very nice.
I'll press OK.
And now we can clearly see what is happening here.
For the last one,
either make the data labels text fill white
or again, select the entire data series.
You can do this even here
by selecting it on the legend.
Shape Fill, let's give it an orange
or a yellow, something that will make this stand out.
Now we can see much, much better what's going on.
Apart from this first data label,
I'll give it a white text.
Now everything is, in my opinion, okay.
We have changed the colors, Control + V.
As a little bonus, I wanna tell you
that if you want, for example,
women to be on the left side here
instead of the largest category first,
you can always press on the bottom axis,
right click, Format Axis.
And there on the right side
is a feature called categories in reverse order.
If you select that,
the categories will reverse.
Of course, you can take the table,
and you can like put the woman higher.
Like editing in Excel but it's a bit quicker
and more convenient if you just select this option.
I hope you can replicate all the steps
and work on this stacked column chart
and in the next lecture,
we will continue to work on a different type of chart.
See you there.